Overview
Brought to you by YData
Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 320696 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 36.7 MiB |
| Average record size in memory | 120.0 B |
Variable types
| Categorical | 4 |
|---|---|
| Numeric | 8 |
| Text | 2 |
| DateTime | 1 |
group_number has constant value "2" | Constant |
day has constant value "Wednesday" | Constant |
batch_number has constant value "4" | Constant |
bath is highly overall correlated with house_size | High correlation |
bed is highly overall correlated with house_size | High correlation |
house_size is highly overall correlated with bath and 1 other fields | High correlation |
bed is highly skewed (γ1 = 181.4931731) | Skewed |
bath is highly skewed (γ1 = 72.34021908) | Skewed |
acre_lot is highly skewed (γ1 = 113.5876888) | Skewed |
Reproduction
| Analysis started | 2025-06-02 05:02:09.999533 |
|---|---|
| Analysis finished | 2025-06-02 05:02:48.126013 |
| Duration | 38.13 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
group_number
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
| 2 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 320696 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 320696 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 320696 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 320696 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 320696 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 320696 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 320696 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 320696 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 320696 |
day
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
| Wednesday |
|---|
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Wednesday |
|---|---|
| 2nd row | Wednesday |
| 3rd row | Wednesday |
| 4th row | Wednesday |
| 5th row | Wednesday |
Common Values
| Value | Count | Frequency (%) |
| Wednesday | 320696 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| wednesday | 320696 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 641392 | |
| d | 641392 | |
| W | 320696 | |
| n | 320696 | |
| s | 320696 | |
| a | 320696 | |
| y | 320696 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2886264 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 641392 | |
| d | 641392 | |
| W | 320696 | |
| n | 320696 | |
| s | 320696 | |
| a | 320696 | |
| y | 320696 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2886264 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 641392 | |
| d | 641392 | |
| W | 320696 | |
| n | 320696 | |
| s | 320696 | |
| a | 320696 | |
| y | 320696 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2886264 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 641392 | |
| d | 641392 | |
| W | 320696 | |
| n | 320696 | |
| s | 320696 | |
| a | 320696 | |
| y | 320696 |
batch_number
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
| 4 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 4 |
| 3rd row | 4 |
| 4th row | 4 |
| 5th row | 4 |
Common Values
| Value | Count | Frequency (%) |
| 4 | 320696 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4 | 320696 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 320696 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 320696 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 320696 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 320696 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 320696 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 320696 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 320696 |
brokered_by
Real number (ℝ)
| Distinct | 45710 |
|---|---|
| Distinct (%) | 14.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54149.016 |
| Minimum | 0 |
|---|---|
| Maximum | 110140 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8727 |
| Q1 | 26419 |
| median | 53083.5 |
| Q3 | 79183 |
| 95-th percentile | 105798 |
| Maximum | 110140 |
| Range | 110140 |
| Interquartile range (IQR) | 52764 |
Descriptive statistics
| Standard deviation | 30154.63 |
|---|---|
| Coefficient of variation (CV) | 0.55688233 |
| Kurtosis | -1.0705028 |
| Mean | 54149.016 |
| Median Absolute Deviation (MAD) | 26137.5 |
| Skewness | 0.075211177 |
| Sum | 1.7365373 × 1010 |
| Variance | 9.0930172 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 22611 | 7468 | 2.3% |
| 53016 | 3986 | 1.2% |
| 16829 | 1960 | 0.6% |
| 70677 | 1906 | 0.6% |
| 71243 | 1847 | 0.6% |
| 30807 | 1743 | 0.5% |
| 84534 | 1501 | 0.5% |
| 70650 | 1361 | 0.4% |
| 33714 | 1291 | 0.4% |
| 79221 | 1252 | 0.4% |
| Other values (45700) | 296381 |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 2 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 8 | 73 | |
| 10 | 1 | < 0.1% |
| 12 | 3 | < 0.1% |
| 14 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 110140 | 1 | < 0.1% |
| 110138 | 11 | < 0.1% |
| 110135 | 2 | < 0.1% |
| 110133 | 5 | < 0.1% |
| 110132 | 2 | < 0.1% |
| 110131 | 3 | < 0.1% |
| 110127 | 1 | < 0.1% |
| 110126 | 14 | < 0.1% |
| 110123 | 2 | < 0.1% |
| 110122 | 51 |
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 5.7416993 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | for_sale |
|---|---|
| 2nd row | for_sale |
| 3rd row | for_sale |
| 4th row | for_sale |
| 5th row | for_sale |
Common Values
| Value | Count | Frequency (%) |
| sold | 181057 | |
| for_sale | 139639 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| sold | 181057 | |
| for_sale | 139639 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 320696 | |
| o | 320696 | |
| l | 320696 | |
| d | 181057 | |
| f | 139639 | |
| r | 139639 | |
| _ | 139639 | |
| a | 139639 | |
| e | 139639 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1841340 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 320696 | |
| o | 320696 | |
| l | 320696 | |
| d | 181057 | |
| f | 139639 | |
| r | 139639 | |
| _ | 139639 | |
| a | 139639 | |
| e | 139639 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1841340 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 320696 | |
| o | 320696 | |
| l | 320696 | |
| d | 181057 | |
| f | 139639 | |
| r | 139639 | |
| _ | 139639 | |
| a | 139639 | |
| e | 139639 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1841340 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 320696 | |
| o | 320696 | |
| l | 320696 | |
| d | 181057 | |
| f | 139639 | |
| r | 139639 | |
| _ | 139639 | |
| a | 139639 | |
| e | 139639 |
price
Real number (ℝ)
| Distinct | 12236 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 397339.42 |
| Minimum | 300023 |
|---|---|
| Maximum | 500000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 300023 |
|---|---|
| 5-th percentile | 315000 |
| Q1 | 349900 |
| median | 395000 |
| Q3 | 445000 |
| 95-th percentile | 497400 |
| Maximum | 500000 |
| Range | 199977 |
| Interquartile range (IQR) | 95100 |
Descriptive statistics
| Standard deviation | 56966.595 |
|---|---|
| Coefficient of variation (CV) | 0.14337011 |
| Kurtosis | -1.1061248 |
| Mean | 397339.42 |
| Median Absolute Deviation (MAD) | 46000 |
| Skewness | 0.20603074 |
| Sum | 1.2742516 × 1011 |
| Variance | 3.2451929 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 350000 | 9010 | 2.8% |
| 325000 | 8474 | 2.6% |
| 425000 | 8204 | 2.6% |
| 450000 | 8014 | 2.5% |
| 375000 | 7552 | 2.4% |
| 399900 | 6502 | 2.0% |
| 475000 | 6263 | 2.0% |
| 349900 | 5981 | 1.9% |
| 399000 | 5394 | 1.7% |
| 315000 | 5166 | 1.6% |
| Other values (12226) | 250136 |
| Value | Count | Frequency (%) |
| 300023 | 1 | |
| 300040 | 1 | |
| 300050 | 1 | |
| 300099 | 1 | |
| 300100 | 1 | |
| 300120 | 1 | |
| 300135 | 1 | |
| 300155 | 1 | |
| 300190 | 1 | |
| 300199 | 1 |
| Value | Count | Frequency (%) |
| 500000 | 3730 | |
| 499999 | 810 | 0.3% |
| 499998 | 15 | < 0.1% |
| 499997 | 8 | < 0.1% |
| 499995 | 54 | < 0.1% |
| 499993 | 1 | < 0.1% |
| 499990 | 221 | 0.1% |
| 499989 | 3 | < 0.1% |
| 499988 | 2 | < 0.1% |
| 499987 | 2 | < 0.1% |
bed
Real number (ℝ)
High correlation Skewed
| Distinct | 26 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.3523649 |
| Minimum | 1 |
|---|---|
| Maximum | 444 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 444 |
| Range | 443 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.4339532 |
|---|---|
| Coefficient of variation (CV) | 0.42774378 |
| Kurtosis | 55616.175 |
| Mean | 3.3523649 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 181.49317 |
| Sum | 1075090 |
| Variance | 2.0562219 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=26)
| Value | Count | Frequency (%) |
| 3 | 155576 | |
| 4 | 100928 | |
| 2 | 37041 | 11.6% |
| 5 | 18878 | 5.9% |
| 1 | 3620 | 1.1% |
| 6 | 3098 | 1.0% |
| 7 | 572 | 0.2% |
| 8 | 496 | 0.2% |
| 9 | 256 | 0.1% |
| 10 | 87 | < 0.1% |
| Other values (16) | 144 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 3620 | 1.1% |
| 2 | 37041 | 11.6% |
| 3 | 155576 | |
| 4 | 100928 | |
| 5 | 18878 | 5.9% |
| 6 | 3098 | 1.0% |
| 7 | 572 | 0.2% |
| 8 | 496 | 0.2% |
| 9 | 256 | 0.1% |
| 10 | 87 | < 0.1% |
| Value | Count | Frequency (%) |
| 444 | 2 | < 0.1% |
| 41 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 38 | 1 | < 0.1% |
| 33 | 1 | < 0.1% |
| 22 | 2 | < 0.1% |
| 21 | 2 | < 0.1% |
| 20 | 2 | < 0.1% |
| 18 | 7 | |
| 17 | 2 | < 0.1% |
bath
Real number (ℝ)
High correlation Skewed
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4906609 |
| Minimum | 1 |
|---|---|
| Maximum | 222 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 222 |
| Range | 221 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.0113037 |
|---|---|
| Coefficient of variation (CV) | 0.40603827 |
| Kurtosis | 14733.262 |
| Mean | 2.4906609 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 72.340219 |
| Sum | 798745 |
| Variance | 1.0227351 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=22)
| Value | Count | Frequency (%) |
| 2 | 152966 | |
| 3 | 114246 | |
| 4 | 27883 | 8.7% |
| 1 | 22782 | 7.1% |
| 5 | 2225 | 0.7% |
| 6 | 417 | 0.1% |
| 7 | 75 | < 0.1% |
| 8 | 62 | < 0.1% |
| 9 | 12 | < 0.1% |
| 10 | 5 | < 0.1% |
| Other values (12) | 23 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 22782 | 7.1% |
| 2 | 152966 | |
| 3 | 114246 | |
| 4 | 27883 | 8.7% |
| 5 | 2225 | 0.7% |
| 6 | 417 | 0.1% |
| 7 | 75 | < 0.1% |
| 8 | 62 | < 0.1% |
| 9 | 12 | < 0.1% |
| 10 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 222 | 2 | |
| 113 | 2 | |
| 25 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 16 | 3 | |
| 15 | 2 | |
| 14 | 1 | < 0.1% |
| 13 | 3 |
acre_lot
Real number (ℝ)
Skewed
| Distinct | 2854 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.985941 |
| Minimum | 0 |
|---|---|
| Maximum | 100000 |
| Zeros | 524 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.04 |
| Q1 | 0.14 |
| median | 0.21 |
| Q3 | 0.37 |
| 95-th percentile | 2.9 |
| Maximum | 100000 |
| Range | 100000 |
| Interquartile range (IQR) | 0.23 |
Descriptive statistics
| Standard deviation | 744.3326 |
|---|---|
| Coefficient of variation (CV) | 74.538054 |
| Kurtosis | 14063.843 |
| Mean | 9.985941 |
| Median Absolute Deviation (MAD) | 0.09 |
| Skewness | 113.58769 |
| Sum | 3202451.3 |
| Variance | 554031.03 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.14 | 14934 | 4.7% |
| 0.17 | 14784 | 4.6% |
| 0.16 | 13106 | 4.1% |
| 0.15 | 12515 | 3.9% |
| 0.18 | 11785 | 3.7% |
| 0.23 | 11612 | 3.6% |
| 0.19 | 10722 | 3.3% |
| 0.13 | 10259 | 3.2% |
| 0.2 | 9276 | 2.9% |
| 0.11 | 8823 | 2.8% |
| Other values (2844) | 202880 |
| Value | Count | Frequency (%) |
| 0 | 524 | 0.2% |
| 0.01 | 1492 | 0.5% |
| 0.02 | 4029 | |
| 0.03 | 5628 | |
| 0.04 | 5841 | |
| 0.05 | 5070 | |
| 0.06 | 4461 | |
| 0.07 | 4196 | |
| 0.08 | 3728 | |
| 0.09 | 4880 |
| Value | Count | Frequency (%) |
| 100000 | 11 | |
| 90124 | 1 | < 0.1% |
| 86139 | 1 | < 0.1% |
| 85442 | 1 | < 0.1% |
| 80135 | 1 | < 0.1% |
| 65145 | 1 | < 0.1% |
| 50120 | 1 | < 0.1% |
| 49312 | 2 | < 0.1% |
| 48136 | 1 | < 0.1% |
| 43560 | 2 | < 0.1% |
street
Real number (ℝ)
| Distinct | 297041 |
|---|---|
| Distinct (%) | 92.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 931214.71 |
| Minimum | 614 |
|---|---|
| Maximum | 2000878 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 614 |
|---|---|
| 5-th percentile | 104493.25 |
| Q1 | 466395.25 |
| median | 932876 |
| Q3 | 1396147.5 |
| 95-th percentile | 1751390.8 |
| Maximum | 2000878 |
| Range | 2000264 |
| Interquartile range (IQR) | 929752.25 |
Descriptive statistics
| Standard deviation | 531165.7 |
|---|---|
| Coefficient of variation (CV) | 0.57040089 |
| Kurtosis | -1.2112578 |
| Mean | 931214.71 |
| Median Absolute Deviation (MAD) | 464907.5 |
| Skewness | -0.0031399269 |
| Sum | 2.9863683 × 1011 |
| Variance | 2.82137 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1070683 | 4 | < 0.1% |
| 1372701 | 4 | < 0.1% |
| 1708619 | 3 | < 0.1% |
| 1239644 | 3 | < 0.1% |
| 1418212 | 3 | < 0.1% |
| 1564648 | 3 | < 0.1% |
| 1074475 | 3 | < 0.1% |
| 113008 | 3 | < 0.1% |
| 914969 | 3 | < 0.1% |
| 201177 | 3 | < 0.1% |
| Other values (297031) | 320664 |
| Value | Count | Frequency (%) |
| 614 | 1 | |
| 1796 | 1 | |
| 2905 | 1 | |
| 3161 | 1 | |
| 3913 | 1 | |
| 3920 | 1 | |
| 4276 | 1 | |
| 4279 | 1 | |
| 4321 | 1 | |
| 4331 | 1 |
| Value | Count | Frequency (%) |
| 2000878 | 1 | |
| 2000549 | 1 | |
| 1998390 | 1 | |
| 1997958 | 1 | |
| 1996636 | 1 | |
| 1995345 | 1 | |
| 1994989 | 1 | |
| 1994678 | 1 | |
| 1994246 | 1 | |
| 1994239 | 1 |
city
Text
| Distinct | 9936 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 25 |
| Mean length | 8.9727249 |
| Min length | 2 |
Unique
| Unique | 2352 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | Agawam |
|---|---|
| 2nd row | Pelham |
| 3rd row | Amherst |
| 4th row | Amherst |
| 5th row | Amherst |
| Value | Count | Frequency (%) |
| city | 7832 | 1.9% |
| saint | 5079 | 1.2% |
| houston | 4860 | 1.2% |
| fort | 4458 | 1.1% |
| valley | 4451 | 1.1% |
| lake | 3704 | 0.9% |
| beach | 3694 | 0.9% |
| phoenix | 3628 | 0.9% |
| san | 3593 | 0.9% |
| tucson | 3035 | 0.7% |
| Other values (7940) | 368981 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 271817 | 9.4% |
| a | 250615 | 8.7% |
| o | 220433 | 7.7% |
| n | 209213 | 7.3% |
| l | 193351 | 6.7% |
| r | 186272 | 6.5% |
| i | 171090 | 5.9% |
| t | 154101 | 5.4% |
| s | 119041 | 4.1% |
| 92619 | 3.2% | |
| Other values (44) | 1008965 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2877517 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 271817 | 9.4% |
| a | 250615 | 8.7% |
| o | 220433 | 7.7% |
| n | 209213 | 7.3% |
| l | 193351 | 6.7% |
| r | 186272 | 6.5% |
| i | 171090 | 5.9% |
| t | 154101 | 5.4% |
| s | 119041 | 4.1% |
| 92619 | 3.2% | |
| Other values (44) | 1008965 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2877517 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 271817 | 9.4% |
| a | 250615 | 8.7% |
| o | 220433 | 7.7% |
| n | 209213 | 7.3% |
| l | 193351 | 6.7% |
| r | 186272 | 6.5% |
| i | 171090 | 5.9% |
| t | 154101 | 5.4% |
| s | 119041 | 4.1% |
| 92619 | 3.2% | |
| Other values (44) | 1008965 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2877517 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 271817 | 9.4% |
| a | 250615 | 8.7% |
| o | 220433 | 7.7% |
| n | 209213 | 7.3% |
| l | 193351 | 6.7% |
| r | 186272 | 6.5% |
| i | 171090 | 5.9% |
| t | 154101 | 5.4% |
| s | 119041 | 4.1% |
| 92619 | 3.2% | |
| Other values (44) | 1008965 |
state
Text
| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 13 |
| Mean length | 8.1586019 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Massachusetts |
|---|---|
| 2nd row | Massachusetts |
| 3rd row | Massachusetts |
| 4th row | Massachusetts |
| 5th row | Massachusetts |
| Value | Count | Frequency (%) |
| florida | 39633 | 11.2% |
| texas | 37637 | 10.6% |
| california | 32118 | 9.1% |
| arizona | 22715 | 6.4% |
| georgia | 15665 | 4.4% |
| new | 15118 | 4.3% |
| washington | 13881 | 3.9% |
| carolina | 12872 | 3.6% |
| virginia | 12625 | 3.6% |
| maryland | 12235 | 3.5% |
| Other values (49) | 139068 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 365017 | |
| i | 288673 | 11.0% |
| o | 233625 | 8.9% |
| n | 225209 | 8.6% |
| r | 191314 | 7.3% |
| s | 158783 | 6.1% |
| e | 148561 | 5.7% |
| l | 144513 | 5.5% |
| d | 69782 | 2.7% |
| t | 64085 | 2.4% |
| Other values (36) | 726869 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2616431 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 365017 | |
| i | 288673 | 11.0% |
| o | 233625 | 8.9% |
| n | 225209 | 8.6% |
| r | 191314 | 7.3% |
| s | 158783 | 6.1% |
| e | 148561 | 5.7% |
| l | 144513 | 5.5% |
| d | 69782 | 2.7% |
| t | 64085 | 2.4% |
| Other values (36) | 726869 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2616431 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 365017 | |
| i | 288673 | 11.0% |
| o | 233625 | 8.9% |
| n | 225209 | 8.6% |
| r | 191314 | 7.3% |
| s | 158783 | 6.1% |
| e | 148561 | 5.7% |
| l | 144513 | 5.5% |
| d | 69782 | 2.7% |
| t | 64085 | 2.4% |
| Other values (36) | 726869 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2616431 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 365017 | |
| i | 288673 | 11.0% |
| o | 233625 | 8.9% |
| n | 225209 | 8.6% |
| r | 191314 | 7.3% |
| s | 158783 | 6.1% |
| e | 148561 | 5.7% |
| l | 144513 | 5.5% |
| d | 69782 | 2.7% |
| t | 64085 | 2.4% |
| Other values (36) | 726869 |
zip_code
Real number (ℝ)
| Distinct | 16479 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55301.378 |
| Minimum | 612 |
|---|---|
| Maximum | 99901 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 612 |
|---|---|
| 5-th percentile | 8088 |
| Q1 | 30101 |
| median | 55406 |
| Q3 | 85034 |
| 95-th percentile | 97424 |
| Maximum | 99901 |
| Range | 99289 |
| Interquartile range (IQR) | 54933 |
Descriptive statistics
| Standard deviation | 30004.256 |
|---|---|
| Coefficient of variation (CV) | 0.54255893 |
| Kurtosis | -1.420597 |
| Mean | 55301.378 |
| Median Absolute Deviation (MAD) | 26072 |
| Skewness | -0.059961202 |
| Sum | 1.7734931 × 1010 |
| Variance | 9.0025541 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 85138 | 956 | 0.3% |
| 85326 | 545 | 0.2% |
| 85122 | 521 | 0.2% |
| 77494 | 486 | 0.2% |
| 77007 | 456 | 0.1% |
| 34746 | 430 | 0.1% |
| 92345 | 413 | 0.1% |
| 76179 | 408 | 0.1% |
| 85375 | 403 | 0.1% |
| 85143 | 399 | 0.1% |
| Other values (16469) | 315679 |
| Value | Count | Frequency (%) |
| 612 | 1 | |
| 677 | 1 | |
| 718 | 1 | |
| 725 | 1 | |
| 727 | 1 | |
| 736 | 1 | |
| 738 | 1 | |
| 745 | 1 | |
| 765 | 2 | |
| 778 | 1 |
| Value | Count | Frequency (%) |
| 99901 | 7 | < 0.1% |
| 99827 | 1 | < 0.1% |
| 99824 | 1 | < 0.1% |
| 99801 | 19 | |
| 99712 | 5 | < 0.1% |
| 99709 | 10 | |
| 99705 | 14 | |
| 99701 | 4 | < 0.1% |
| 99672 | 1 | < 0.1% |
| 99669 | 5 | < 0.1% |
house_size
Real number (ℝ)
High correlation
| Distinct | 5080 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1981.6458 |
| Minimum | 100 |
|---|---|
| Maximum | 54892 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 1021 |
| Q1 | 1484 |
| median | 1872 |
| Q3 | 2356 |
| 95-th percentile | 3255 |
| Maximum | 54892 |
| Range | 54792 |
| Interquartile range (IQR) | 872 |
Descriptive statistics
| Standard deviation | 796.87584 |
|---|---|
| Coefficient of variation (CV) | 0.40212828 |
| Kurtosis | 221.36423 |
| Mean | 1981.6458 |
| Median Absolute Deviation (MAD) | 428 |
| Skewness | 6.9225109 |
| Sum | 6.3550589 × 108 |
| Variance | 635011.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1800 | 1308 | 0.4% |
| 2000 | 1053 | 0.3% |
| 1600 | 1051 | 0.3% |
| 1500 | 985 | 0.3% |
| 1200 | 979 | 0.3% |
| 2200 | 907 | 0.3% |
| 1440 | 881 | 0.3% |
| 1700 | 826 | 0.3% |
| 2100 | 822 | 0.3% |
| 1400 | 820 | 0.3% |
| Other values (5070) | 311064 |
| Value | Count | Frequency (%) |
| 100 | 2 | |
| 121 | 2 | |
| 150 | 1 | |
| 170 | 1 | |
| 200 | 2 | |
| 210 | 1 | |
| 228 | 1 | |
| 251 | 1 | |
| 255 | 1 | |
| 266 | 1 |
| Value | Count | Frequency (%) |
| 54892 | 1 | < 0.1% |
| 40720 | 1 | < 0.1% |
| 39996 | 1 | < 0.1% |
| 36808 | 1 | < 0.1% |
| 34690 | 1 | < 0.1% |
| 29997 | 9 | |
| 28750 | 1 | < 0.1% |
| 24400 | 1 | < 0.1% |
| 21519 | 2 | < 0.1% |
| 21500 | 1 | < 0.1% |
prev_sold_date
Date
| Distinct | 10772 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
| Minimum | 1901-01-01 00:00:00 |
|---|---|
| Maximum | 2024-04-17 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Interactions
Correlations
| acre_lot | bath | bed | brokered_by | house_size | price | status | street | zip_code | |
|---|---|---|---|---|---|---|---|---|---|
| acre_lot | 1.000 | 0.042 | 0.177 | -0.026 | 0.261 | 0.022 | 0.000 | -0.014 | -0.171 |
| bath | 0.042 | 1.000 | 0.486 | -0.023 | 0.651 | 0.142 | 0.000 | -0.015 | -0.206 |
| bed | 0.177 | 0.486 | 1.000 | -0.016 | 0.621 | 0.093 | 0.000 | -0.005 | -0.154 |
| brokered_by | -0.026 | -0.023 | -0.016 | 1.000 | -0.033 | 0.014 | 0.025 | 0.003 | 0.079 |
| house_size | 0.261 | 0.651 | 0.621 | -0.033 | 1.000 | 0.153 | 0.002 | -0.021 | -0.204 |
| price | 0.022 | 0.142 | 0.093 | 0.014 | 0.153 | 1.000 | 0.014 | -0.008 | 0.108 |
| status | 0.000 | 0.000 | 0.000 | 0.025 | 0.002 | 0.014 | 1.000 | 0.016 | 0.152 |
| street | -0.014 | -0.015 | -0.005 | 0.003 | -0.021 | -0.008 | 0.016 | 1.000 | 0.009 |
| zip_code | -0.171 | -0.206 | -0.154 | 0.079 | -0.204 | 0.108 | 0.152 | 0.009 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| group_number | day | batch_number | brokered_by | status | price | bed | bath | acre_lot | street | city | state | zip_code | house_size | prev_sold_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2 | Wednesday | 4 | 97400.0 | for_sale | 384900.0 | 3.0 | 2.0 | 0.46 | 1244899.0 | Agawam | Massachusetts | 1001.0 | 1476.0 | 1986-11-20 |
| 1 | 2 | Wednesday | 4 | 22188.0 | for_sale | 419000.0 | 4.0 | 2.0 | 2.00 | 1417448.0 | Pelham | Massachusetts | 1002.0 | 1607.0 | 2005-07-25 |
| 2 | 2 | Wednesday | 4 | 48733.0 | for_sale | 415000.0 | 4.0 | 2.0 | 0.49 | 816546.0 | Amherst | Massachusetts | 1002.0 | 1814.0 | 1997-06-30 |
| 3 | 2 | Wednesday | 4 | 48733.0 | for_sale | 390000.0 | 3.0 | 2.0 | 0.50 | 236564.0 | Amherst | Massachusetts | 1002.0 | 1128.0 | 1998-09-17 |
| 4 | 2 | Wednesday | 4 | 48733.0 | for_sale | 499900.0 | 4.0 | 3.0 | 0.46 | 197884.0 | Amherst | Massachusetts | 1002.0 | 2143.0 | 1988-06-10 |
| 5 | 2 | Wednesday | 4 | 27510.0 | for_sale | 439900.0 | 3.0 | 2.0 | 0.20 | 1032285.0 | Amherst | Massachusetts | 1002.0 | 1349.0 | 2005-09-02 |
| 6 | 2 | Wednesday | 4 | 110138.0 | for_sale | 397000.0 | 2.0 | 2.0 | 0.51 | 1212530.0 | Granby | Massachusetts | 1033.0 | 2000.0 | 2001-12-13 |
| 7 | 2 | Wednesday | 4 | 101392.0 | for_sale | 389900.0 | 2.0 | 2.0 | 0.92 | 366219.0 | Whately | Massachusetts | 1093.0 | 1723.0 | 1997-09-25 |
| 8 | 2 | Wednesday | 4 | 736.0 | for_sale | 459900.0 | 4.0 | 3.0 | 3.80 | 152461.0 | Sunderland | Massachusetts | 1375.0 | 2768.0 | 2009-07-17 |
| 9 | 2 | Wednesday | 4 | 8147.0 | for_sale | 324900.0 | 4.0 | 2.0 | 0.56 | 985872.0 | Granby | Massachusetts | 1033.0 | 1523.0 | 2007-09-19 |
| group_number | day | batch_number | brokered_by | status | price | bed | bath | acre_lot | street | city | state | zip_code | house_size | prev_sold_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 320686 | 2 | Wednesday | 4 | 33745.0 | sold | 310000.0 | 3.0 | 1.0 | 0.23 | 1594744.0 | Richland | Washington | 99354.0 | 1845.0 | 2022-02-14 |
| 320687 | 2 | Wednesday | 4 | 108210.0 | sold | 425000.0 | 4.0 | 3.0 | 0.25 | 215391.0 | Richland | Washington | 99354.0 | 2732.0 | 2022-02-14 |
| 320688 | 2 | Wednesday | 4 | 108243.0 | sold | 425000.0 | 3.0 | 3.0 | 0.06 | 970797.0 | Richland | Washington | 99354.0 | 1876.0 | 2022-02-14 |
| 320689 | 2 | Wednesday | 4 | 16235.0 | sold | 305000.0 | 4.0 | 2.0 | 0.42 | 353937.0 | Richland | Washington | 99354.0 | 2000.0 | 2022-02-11 |
| 320690 | 2 | Wednesday | 4 | 53860.0 | sold | 310000.0 | 3.0 | 1.0 | 0.21 | 500240.0 | Richland | Washington | 99354.0 | 1152.0 | 2022-02-11 |
| 320691 | 2 | Wednesday | 4 | 60631.0 | sold | 385000.0 | 4.0 | 2.0 | 0.21 | 210890.0 | Richland | Washington | 99354.0 | 1656.0 | 2022-03-28 |
| 320692 | 2 | Wednesday | 4 | 85499.0 | sold | 339900.0 | 4.0 | 2.0 | 0.20 | 41160.0 | Richland | Washington | 99354.0 | 2780.0 | 2022-03-28 |
| 320693 | 2 | Wednesday | 4 | 23009.0 | sold | 359900.0 | 4.0 | 2.0 | 0.33 | 353094.0 | Richland | Washington | 99354.0 | 3600.0 | 2022-03-25 |
| 320694 | 2 | Wednesday | 4 | 18208.0 | sold | 350000.0 | 3.0 | 2.0 | 0.10 | 1062149.0 | Richland | Washington | 99354.0 | 1616.0 | 2022-03-25 |
| 320695 | 2 | Wednesday | 4 | 76856.0 | sold | 440000.0 | 6.0 | 3.0 | 0.50 | 405677.0 | Richland | Washington | 99354.0 | 3200.0 | 2022-03-24 |